CREATE TRIGGER [dbo].[TRIG_DGMYL_GLB_ANALYZE_RESET] 
ON [dbo].[dvip_glb_milk_yield_lact] 
AFTER INSERT, UPDATE, DELETE 
AS 
  BEGIN 
      EXEC [dbo].[Update_glb_analyze_flag]; 
  END; 

GO 

CREATE TRIGGER [dbo].[TRIG_DGMYP_GLB_ANALYZE_RESET] 
ON [dbo].[dvip_glb_milk_yield_preg] 
AFTER INSERT, UPDATE, DELETE 
AS 
  BEGIN 
      EXEC [dbo].[Update_glb_analyze_flag]; 
  END; 

GO 